CREATE PROCEDURE [dbo].[sp_asi_UpdateLastFirst]
AS
    BEGIN

        SET NOCOUNT ON

        SET ROWCOUNT 1000
        DECLARE @isDone BIT
        SET @isDone = 0
        WHILE ( @isDone = 0 )
            BEGIN
                BEGIN TRANSACTION
                UPDATE  Name
                SET     LAST_FIRST = dbo.fn_asi_GetLastFirst(LAST_NAME,
                                                             FIRST_NAME)
                WHERE   LAST_FIRST <> dbo.fn_asi_GetLastFirst(LAST_NAME,
                                                              FIRST_NAME)
                IF @@ROWCOUNT = 0
                    SET @isDone = 1
                COMMIT TRANSACTION
            END
        SET ROWCOUNT 0
    END


GO
GRANT EXECUTE ON  [dbo].[sp_asi_UpdateLastFirst] TO [IMIS]
GO